home *** CD-ROM | disk | FTP | other *** search
- WordStar/MailMerge[TM]/Basica/Output Sequential File
- [also: WordPerfect[TM] Merge and dBASE III [TM] ]
-
- OVERVIEW
-
- Thesσ option≤ creatσ eithe≥ ß WordStar/MailMerge[TM]¼á WordPerfect[TM]¼á o≥ ì
- dBAS┼á II╔á [TM▌ datß filσ usinτ thσ datß froφ you≥ Maste≥á File/dBAS┼á II╔ ì
- file« Thσ newl∙ createΣ filσ end≤ iε thσ letters║ '.DAT'¼ '.SFº o≥ '.DBF'.
-
- Iµ useΣ witΦ Wordstar[TM]¼á thσ .DA╘ filσ caε bσ useΣ t∩ prin⌠ forφ letter≤ ì
- iε MailMerge[TM]«á Al∞ characte≥ field≤ arσ trimmeΣ oµ trailinτ blank≤ t∩ ì
- accommodatσá you≥ forφ letters«á Alonτ witΦ thi≤ datß file¼á thσ Wordsta≥ ì
- optioεá create≤á thσ beginninτ oµ you≥ forφ lette≥ anΣ put≤ i⌠ iεá ßá filσ ì
- endinτá iε thσ │ letter≤ '.DEFº (containinτ al∞ thσ MailMerge[TM▌á command≤ ì
- yo⌡ neeΣ a⌠ thσ star⌠ oµ ß forφ letter)«
-
- Iµá useΣ witΦ WordPerfect[TM]¼á thσ .S╞ filσ i≤ thσ 'Secondar∙á Fileºá tha⌠ ì
- WordPerfec⌠á use≤á fo≥ mergσ letters¼á wherσ eacΦ fielΣ i≤ delimiteΣá witΦ ì
- CONTROL-R¼ anΣ eacΦ recorΣ i≤ delimiteΣ witΦ CONTROL-E.]
-
- Iµ useΣ witΦ dBAS┼ II╔ [TM]¼á thσ '.DBFº filσ forma⌠ i≤ becominτ ß standarΣ ì
- datßá filσ forma⌠ tha⌠ man∙ othe≥ program≤ arσ usinτ fo≥á thei≥á respectivσ ì
- datß impor⌠ function.
-
- Thesσá option≤á wil∞ allo≈ yo⌡ t∩ outpu⌠ thσ ke∙ field≤ iεá you≥á prospec⌠ ì
- filσá t∩á aεá externa∞á tex⌠ filσ tha⌠ can¼á iε turn¼á bσ useΣá b∙á ßá worΣ ì
- processo≥ t∩ creatσ 'boilerplateº o≥ forφ letter≤ fo≥ yo⌡ automatically.
-
- BaseΣá oε you≥ selectioε criteria¼á iµ any¼á thσ prograφ wil∞ outpu⌠á thesσ ì
- fields║
- Primar∙ ID¼ Secondar∙ ID¼ 3rΣ ID¼ Comment≤
-
-
- ==============
- | OPTION 1: |
- ==============
-
- Selection Process:
-
- A⌠ optioε 1¼ yo⌡ caε inpu⌠ u≡ t∩ ╖ searcΦ criteriß a≤ thσ basi≤ fo≥
- you≥ worΣ processo≥ mergσ file║
-
- Primary ID, Secondary ID, 3rd ID, Comment≤
-
- Yo⌡á caε selec⌠ whethe≥ yo⌡ wan⌠ onl∙ thosσ record≤ t∩ bσ selecteΣá tha⌠ ì
- havσá al∞ oµ criteriß iε ever∙ recorΣ o≥ selec⌠ ou⌠ record≤ regardles≤á oµ ì
- thσ numbe≥ oµ matche≤ madσ pe≥ record¼á a≤ lonτ a≤ a⌠ leas⌠ onσ matcΦ i≤ ì
- madσ iε an∙ onσ recorΣ tha⌠ i≤ selected.
-
- Truσ [o≥ T▌ mean≤ al∞ matche≤ havσ t∩ bσ madσ iε an∙ onσ recorΣ fo≥ i⌠ t∩
- bσ selected« Falsσ [o≥ F▌ mean≤ tha⌠ a≤ lonτ a≤ onσ matcΦ i≤ madσ iε ß
- recorΣ i⌠ wil∞ bσ selected.
-
-
- è Search Criteria Selection:
- Option 1:
-
- Yo⌡ caε ente≥ an∙ word¼á phrase¼ o≥ codσ oε whicΦ t∩ basσ you≥ selection« ì
- Iµá lef⌠ blank¼á al∞ record≤ wil∞ bσ selecteΣ out«á Iµ yo⌡ makσ aεá entr∙ ì
- here¼á thσá prograφ wil∞ searcΦ througΦ thσ prospec⌠ filσ anΣ selec⌠á ou⌠ ì
- onl∙ thosσ record≤ tha⌠ mee⌠ you≥ searcΦ criteria.
-
- [Notσ tha⌠ yo⌡ caε havσ u≡ t∩ ╖ differen⌠ code≤ o≥ phrase≤ entereΣ herσá anΣ ì
- al∞á record≤ wil∞ bσ pulleΣ whicΦ havσ an∙ onσ oµ theφ o≥ an∙ combinatioε ì
- oµ them]
-
- ==============
- | OPTION 2: |
- ==============
- 2) Output records to Wordstar/Mailmerge[TM]
-
- Thi≤á optioε i≤ useΣ t∩ ge⌠ datß froφ thσ Master File filσ anΣ outpu⌠ i⌠á t∩á ß ì
- filσá tha⌠á caε bσ useΣ b∙ WordStar/MailMerge[TM]«á Thi≤ filσ caε als∩á bσ ì
- useΣ b∙ BASI├ anΣ othe≥ language≤ anΣ products«á Iε short¼á an∙ produc⌠ tha⌠ ì
- accept≤á "commß delimitedó file≤ fo≥ inpu⌠ ma∙ accep⌠ thσ filσá createΣá b∙ ì
- thi≤ option.
-
- Froφ thσ WordSta≥ option¼á yo⌡ wil∞ creatσ tw∩ files« Thσ firs⌠ filσ namσ ì
- end≤á iε .DE╞ anΣ i≤ ß filσ tha⌠ caε bσ turneΣ int∩ ß forφ lette≥á jus⌠á b∙ ì
- callinτ i⌠ u≡ iε WordSta≥ anΣ matchinτ i⌠ t∩ you≥ forφ letter«á I⌠ alread∙ ì
- contain≤á al∞á oµá thσá command≤á needeΣ b∙ WordSta≥á t∩á reaΣá thσá Maste≥ ì
- File/dBAS┼ II╔ datß filσ (.DAT).
-
- Thσ othe≥ filσ i≤ thσ .DA╘ file¼á whicΦ contain≤ al∞ datß tha⌠ yo⌡ wan⌠ t∩ ì
- reaΣ int∩ WordStar«á I⌠ i≤ formatteΣ sequentia∞ file¼á witΦ al∞ field≤á iε ì
- quote≤ anΣ separateΣ b∙ commas«
-
-
- ==============
- ⁿ OPTIO╬ 3║ |
- ==============
-
- 3) Output records to WordPerfect[TM]
-
- Thσá .S╞á filσá i≤á thσ 'Secondar∙ Fileº tha⌠ WordPerfec⌠á use≤á fo≥á mergσ ì
- letters¼á wherσ eacΦ fielΣ i≤ delimiteΣ witΦ CONTROL-R¼á anΣ eacΦ recorΣ i≤ ì
- delimiteΣ witΦ CONTROL-E.]
-
-
-
- ==============
- | OPTION 4: |
- ==============
-
- 4) Output records to dBASE III [Registered TM]
-
-
- WitΦá optioεá 4¼á thσ '.DBFº filσ forma⌠ i≤ becominτ ßá standarΣá datßá filσ ì
- forma⌠á tha⌠ man∙ othe≥ program≤ arσ usinτ fo≥ thei≥ respectivσ datßá impor⌠ ìèfunction«
-
- Oncσá yo⌡ assigε ß namσ t∩ thσ dBAS┼ II╔ [TM▌ filσ yo⌡ arσá outputting¼á thσ ì
- structurσ oµ tha⌠ filσ is:
-
- Field Field Name Type Width Dec
- 1 FNAME Character 20 <======== 3rd ID
- 2 LNAME Character 20 <======== 2nd ID
- 3 PROSPECT Character 40 <======== Primary ID
- 4 COMMENT1 Character 60
- 5 COMMENT2 Character 60
-
- ** Total ** 201
-
-